UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '48oFZbOKuDMSqQlqq+Qrg1ZjsgeNQl4dbYF5SJUX99k='
WHERE
key_id = 'b517f2771485e4126e6e68b5358a3b436f19a6ca4a74b464230084f9a9f6c05d'
AND (
token = '48oFZbOKuDMSqQlqq+Qrg1ZjsgeNQl4dbYF5SJUX99k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)