UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TplYb77ew2tigK8ZRA0pTKVDSU9JwHN9woZC8WZUhSY='
WHERE
key_id = '4e2d58fdae058fa7bf4eb08954092d2658b9ef202c83083eeddabf3a3747aab0'
AND (
token = 'TplYb77ew2tigK8ZRA0pTKVDSU9JwHN9woZC8WZUhSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)