UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zLfBQOJEi/GX7BG+owzp5vRaH0pG3Q3PLmEuNyTFfs='
WHERE
key_id = 'f23e6c231dfeed9cfa4e57f13068ac64393421a1ccc04fbb406d5abfdc2d9eef'
AND (
token = '6zLfBQOJEi/GX7BG+owzp5vRaH0pG3Q3PLmEuNyTFfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)