UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4zqrRlau3RRSPM5Uq72c8+K2RTnGLww+e2zcpbsaEME='
WHERE
key_id = 'a7c4e782a9e348c0e96db0470588fe29ec23d808ef8a5e20b5428730ef3e27fc'
AND (
token = '4zqrRlau3RRSPM5Uq72c8+K2RTnGLww+e2zcpbsaEME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)