UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BqARfp7/4fMV9bgdtT2757rthotx4VkxB2vRyq9xyos='
WHERE
key_id = 'a511066aa477a8f253aa5920f523b44ade2a58079a80e4dabc2a5815929e7b15'
AND (
token = 'BqARfp7/4fMV9bgdtT2757rthotx4VkxB2vRyq9xyos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)