UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPn+UF/VJxFcSOlNfZCN8WViF9VQqKi9P4lZYUEF47M='
WHERE
key_id = 'a6d55931f6dc4fe898326831fee85c4cc38fd2fb4c007cc78f1172a1345c0055'
AND (
token = 'YPn+UF/VJxFcSOlNfZCN8WViF9VQqKi9P4lZYUEF47M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)