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