UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpRTjuDrk6naTTnVFnE8b1AZCMt8qLoL6MNx6E8YBrA='
WHERE
key_id = '743470d5395f4290ef0aea63010e1428125d91f8936d8f9f5eb48ff1cd9ca5de'
AND (
token = 'ZpRTjuDrk6naTTnVFnE8b1AZCMt8qLoL6MNx6E8YBrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)