UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jFUL83DgEKgcunDNeAZ4i2RfpddglJ1gqSFCuif+dxo='
WHERE
key_id = '604d392b688b8e43411a0aad74f347ee92a34db494e22f24a73d7d31dddfac70'
AND (
token = 'jFUL83DgEKgcunDNeAZ4i2RfpddglJ1gqSFCuif+dxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)