UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oKqZUtek8eBY2j2Cp3wHOxx+lR044/T9MHf9J8djEl0='
WHERE
key_id = '16d57c131fcc64367935b3660f804552202e0d36b1f9a7ceb8de7a3564a92018'
AND (
token = 'oKqZUtek8eBY2j2Cp3wHOxx+lR044/T9MHf9J8djEl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)