UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Ji77Uu3gK1FWp6YgxKbwseBzXaFFiJvSulslKNftdo='
WHERE
key_id = '8e1fda567e93340a6e9d839ea64804901bbbff2d1bf36a5a413302fd211c0e6e'
AND (
token = '0Ji77Uu3gK1FWp6YgxKbwseBzXaFFiJvSulslKNftdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)