UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KU6Jd+Kj6M2Xg04VeqIG+vABa2VHsViO8dH88oxOsCc='
WHERE
key_id = '49d1e41a610c097c86edea45a25946c517ef5fc7f419ca7cffce224be7306f99'
AND (
token = 'KU6Jd+Kj6M2Xg04VeqIG+vABa2VHsViO8dH88oxOsCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)