UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XSoU613gliheikwHFtk3kUEPQ3xb45Aae1qSx6Cz8pA='
WHERE
key_id = '6db32d430d36299e9f5e2c4125c4e04bf04afbb3de2f29517bdcbc0f38231c91'
AND (
token = 'XSoU613gliheikwHFtk3kUEPQ3xb45Aae1qSx6Cz8pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)