UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRatfp2n1AxLtEHBaY5uPeUfKE5aygva6LF8hfc9GSE='
WHERE
key_id = '580fdc3e18682cbaa338e73f4417b0806f2622ad9f2653d394d723a2d83a8043'
AND (
token = 'pRatfp2n1AxLtEHBaY5uPeUfKE5aygva6LF8hfc9GSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)