UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VamvZdpoaIe9Hrh8JtKN1rou6/ZNYU7j2AF3J5U4lyA='
WHERE
key_id = 'f09d486f997b2b2cead9c396ad0104c635b00f00888c2f3dc0f81bc1d5eefd7c'
AND (
token = 'VamvZdpoaIe9Hrh8JtKN1rou6/ZNYU7j2AF3J5U4lyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)