UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dLIcW7X67JoSpAUz9MgPviM+dwb2pCQ4zN+HJz95iH8='
WHERE
key_id = '1d120f5ec889dc53e29190f4fe01bb1bd6bf6f627bcabd5e4fa29a85ba8165b9'
AND (
token = 'dLIcW7X67JoSpAUz9MgPviM+dwb2pCQ4zN+HJz95iH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)