UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'goS7mqDl0w6PYoax3e9GIw0ET27WengZnX27lOIs308='
WHERE
key_id = '8594d70706361d54f0e3cb997aa77fd307644d7e33f61333c3836c049e405e67'
AND (
token = 'goS7mqDl0w6PYoax3e9GIw0ET27WengZnX27lOIs308='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)