UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdNFWnPJWsVFvxc0cWvooEjl/zKa4UCtI8h683tnVrA='
WHERE
key_id = 'a3c853b0ac977f29a74a1ffb1d2806f4a4be0cb5517bcc240604156b44edd917'
AND (
token = 'ZdNFWnPJWsVFvxc0cWvooEjl/zKa4UCtI8h683tnVrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)