UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fhJEy2XHMjK7gTtJhw/vqj20I0Nq+uByF4vClT92p8E='
WHERE
key_id = '6f9550e4684a79f46273a416844dfc9922a1055de97b4ca875df2caac78ef96a'
AND (
token = 'fhJEy2XHMjK7gTtJhw/vqj20I0Nq+uByF4vClT92p8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)