UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xrzpM9zKyg5/3LHSQRiIZPiBxqAezAc2kt3ck6QSIp8='
WHERE
key_id = '57dd3d07f8dfd6a12c377b4d4a568e394a094b8650eae65ae6edab2f4a9075d8'
AND (
token = 'xrzpM9zKyg5/3LHSQRiIZPiBxqAezAc2kt3ck6QSIp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)