UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bv6qCBsM5xGmGsrz+14GAbEZhXl8rVe3Nal5v60e/X4='
WHERE
key_id = '468709837b3f3a7f03ce62fc0c93977088de475e866b2b3f591be00427d07628'
AND (
token = 'Bv6qCBsM5xGmGsrz+14GAbEZhXl8rVe3Nal5v60e/X4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)