UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKEdJnL6jdvmmLSgZNFsMelQtdBiA+XuzGOFBlvnPgI='
WHERE
key_id = 'aaf7c4ae55b7e03105b81c6c0746f30abbeff5dcb9ae91e2ff199f00133fe96a'
AND (
token = 'pKEdJnL6jdvmmLSgZNFsMelQtdBiA+XuzGOFBlvnPgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)