UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nRgP8wNICqaQcjKoVc259Y7zihjlkqqI+S7P+PX0mkA='
WHERE
key_id = 'd8a8deab160a59737393998fb68f8cfa05172c5de27eeb7de1eba7dea75bda86'
AND (
token = 'nRgP8wNICqaQcjKoVc259Y7zihjlkqqI+S7P+PX0mkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)