UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nTSbCRVv/PCOZ9g9dJTDJHpX+0HJZ+/rKfGdVI199PU='
WHERE
key_id = '8a4562849a6df7e56b0e3c30450f6bbb9e393d0b06696253f51daa65c099015a'
AND (
token = 'nTSbCRVv/PCOZ9g9dJTDJHpX+0HJZ+/rKfGdVI199PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)