UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v6eEBcptiKKedbF1dnYYyIPudRePEMoQzuE41k741nw='
WHERE
key_id = '93c7cf428d4e52b6354781f89e2d7ab459d7613d3dd671029ef5e16e4ba7caf0'
AND (
token = 'v6eEBcptiKKedbF1dnYYyIPudRePEMoQzuE41k741nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)