UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4M0EwnKI0tOcT8W6X10I0hFdf9BS3LkgpjGTo6BgF8='
WHERE
key_id = '5540d0c1e10ac4ab11a831b46960dc4d1e7bae9ff6433b87a8d1e3c0df034694'
AND (
token = 'H4M0EwnKI0tOcT8W6X10I0hFdf9BS3LkgpjGTo6BgF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)