UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+33RGeH4s1QPlxUiU5p9KlEw/9tbLbQ/vOmBC5CtdhI='
WHERE
key_id = '31fbca41874d6c57912067bb2772f240e16345ba3d22c2951ba21802bcd41ec7'
AND (
token = '+33RGeH4s1QPlxUiU5p9KlEw/9tbLbQ/vOmBC5CtdhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)