UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fyQq+9ttqNqvgsLmNbIq6Jf/NFxSt33MzGrh81PXHoY='
WHERE
key_id = '5555fdfdc182cfd7d77c3acb03ebe3eb2d15dc73ba33f69bede28b8f33db7b8b'
AND (
token = 'fyQq+9ttqNqvgsLmNbIq6Jf/NFxSt33MzGrh81PXHoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)