UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8bV38tDwQpj7HsmvCon/MtqklSL+f7Eg8F1Kh+skt4='
WHERE
key_id = '50164c264a67ff5e5896f3ed3e9805e54f2723173d6d37d895bd70a3aa1a1f21'
AND (
token = 'G8bV38tDwQpj7HsmvCon/MtqklSL+f7Eg8F1Kh+skt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)