UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aN5lf2mTd4UokbBwKRqAOJOKwFYueFgIa/78yS2U6W0='
WHERE
key_id = '7e29c9bebb6edb9bcf2201450f2d016275debfb527252645f3499975a0b084e0'
AND (
token = 'aN5lf2mTd4UokbBwKRqAOJOKwFYueFgIa/78yS2U6W0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)