UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CPAFWv5hE4D+zkENinZLs7KcE7kCTEZH6UtuqcUD2+U='
WHERE
key_id = '14c7fcf374ffa3d327ab581791821f02a112de4951d667d342653887be4cf7b9'
AND (
token = 'CPAFWv5hE4D+zkENinZLs7KcE7kCTEZH6UtuqcUD2+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)