UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ThZtUV2mxZSrzM/I3u2qad0zGVosTbpbgG8i0o01SpQ='
WHERE
key_id = '8a61fd4a53ae2998b43385876e07317306bcd2ab1e5913b22ed4bfa2d8ce8545'
AND (
token = 'ThZtUV2mxZSrzM/I3u2qad0zGVosTbpbgG8i0o01SpQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)