UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ts46HMhWdrlwaRrqLUPW5S539hDxAVkxHfupLlf1LDA='
WHERE
key_id = 'b8190e11d6f99989fdab29b4b21043f60fb9ff38a41ab8023c4927db6ade198d'
AND (
token = 'ts46HMhWdrlwaRrqLUPW5S539hDxAVkxHfupLlf1LDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)