UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4Tw1wPqwzKAGeazMQhg6XfDmHFvFKLGxwI4M1fXsLk='
WHERE
key_id = 'a6468f982a88305c7ec4c68cc332b4027cd66b2f350e8707f50ed175cb05907a'
AND (
token = 'd4Tw1wPqwzKAGeazMQhg6XfDmHFvFKLGxwI4M1fXsLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)