UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRNSpmXO9rZitmwyIcfM38/yJmmLr7GbgCEhIhcxjtM='
WHERE
key_id = '70fc19e67b7cea7b0860cdb7b85034fa2661b59d8d5a49a3f5de36ac6e42f646'
AND (
token = 'pRNSpmXO9rZitmwyIcfM38/yJmmLr7GbgCEhIhcxjtM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)