UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VXRuY9WSxVD3ZY7SBut6zuBXZ6JCeo+r6fbO9pIq+c='
WHERE
key_id = '9319236f74990b2ee85d57e949da68010568d44badc5a836f93384a8c4625df2'
AND (
token = '3VXRuY9WSxVD3ZY7SBut6zuBXZ6JCeo+r6fbO9pIq+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)