UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ANoc2UBbqUv7qAFpQwQ5WusVX1222kgQA8UZf24e9bM='
WHERE
key_id = 'd3ca80dd72393332cff4de34fefb3a0cd6dccc7d349a7e620506ac5415cda8c2'
AND (
token = 'ANoc2UBbqUv7qAFpQwQ5WusVX1222kgQA8UZf24e9bM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)