UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dIJq/3dNIZ1jb3E3/Zg2KVHs4vZmZzmBmqP0jXhSLU8='
WHERE
key_id = 'dd716344d9e61fdb1bd2c3561e6a2a0520f0195407387789e22977d1a60b51e3'
AND (
token = 'dIJq/3dNIZ1jb3E3/Zg2KVHs4vZmZzmBmqP0jXhSLU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)