UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mC47G2w91jGSpBtgSKUNX9RUNB0sx06m6D8vowp1M6Q='
WHERE
key_id = '36be9123671e664ffd75163e856dd47871c00c1316b5ee6ced0452dbc2ad85bf'
AND (
token = 'mC47G2w91jGSpBtgSKUNX9RUNB0sx06m6D8vowp1M6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)