UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RZ9C78xksWCqDQZfmrmRYsA/TpGLNI3vpIKemKHrHP8='
WHERE
key_id = 'eeb1f1582769104471f13470fb555d54e653f17c61a3e4e1e1e7f81e132e1a04'
AND (
token = 'RZ9C78xksWCqDQZfmrmRYsA/TpGLNI3vpIKemKHrHP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)