UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zp8z9iLnnMAMl9HoVIzeNxjKW1LhLuyQN8TuscE2MUM='
WHERE
key_id = '6bd00339096e082485941ee0e9cb6eb79dc0122c9b25a38d7ce773b4162ce556'
AND (
token = 'zp8z9iLnnMAMl9HoVIzeNxjKW1LhLuyQN8TuscE2MUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)